package com.ray.depot.table.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class MaterialExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    /**
     *
     */
    public MaterialExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *
     * @param orderByClause
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *
     * @param distinct
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *
     * @param criteria
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     *
     * @param limitStart
     */
    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    /**
     *
     */
    public int getLimitStart() {
        return limitStart;
    }

    /**
     *
     * @param limitEnd
     */
    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    /**
     *
     */
    public int getLimitEnd() {
        return limitEnd;
    }

    /**
     * 类注释
     * GeneratedCriteria
     * 数据库表：dpt_material
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andMaterialIdIsNull() {
            addCriterion("MATERIAL_ID is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIdIsNotNull() {
            addCriterion("MATERIAL_ID is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialIdEqualTo(String value) {
            addCriterion("MATERIAL_ID =", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotEqualTo(String value) {
            addCriterion("MATERIAL_ID <>", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdGreaterThan(String value) {
            addCriterion("MATERIAL_ID >", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_ID >=", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLessThan(String value) {
            addCriterion("MATERIAL_ID <", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_ID <=", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLike(String value) {
            addCriterion("MATERIAL_ID like", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotLike(String value) {
            addCriterion("MATERIAL_ID not like", value, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdIn(List<String> values) {
            addCriterion("MATERIAL_ID in", values, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotIn(List<String> values) {
            addCriterion("MATERIAL_ID not in", values, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdBetween(String value1, String value2) {
            addCriterion("MATERIAL_ID between", value1, value2, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_ID not between", value1, value2, "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialNameIsNull() {
            addCriterion("MATERIAL_NAME is null");
            return (Criteria) this;
        }

        public Criteria andMaterialNameIsNotNull() {
            addCriterion("MATERIAL_NAME is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialNameEqualTo(String value) {
            addCriterion("MATERIAL_NAME =", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameNotEqualTo(String value) {
            addCriterion("MATERIAL_NAME <>", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameGreaterThan(String value) {
            addCriterion("MATERIAL_NAME >", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_NAME >=", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameLessThan(String value) {
            addCriterion("MATERIAL_NAME <", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_NAME <=", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameLike(String value) {
            addCriterion("MATERIAL_NAME like", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameNotLike(String value) {
            addCriterion("MATERIAL_NAME not like", value, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameIn(List<String> values) {
            addCriterion("MATERIAL_NAME in", values, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameNotIn(List<String> values) {
            addCriterion("MATERIAL_NAME not in", values, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameBetween(String value1, String value2) {
            addCriterion("MATERIAL_NAME between", value1, value2, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialNameNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_NAME not between", value1, value2, "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeIsNull() {
            addCriterion("MATERIAL_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeIsNotNull() {
            addCriterion("MATERIAL_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeEqualTo(String value) {
            addCriterion("MATERIAL_TYPE =", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeNotEqualTo(String value) {
            addCriterion("MATERIAL_TYPE <>", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeGreaterThan(String value) {
            addCriterion("MATERIAL_TYPE >", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_TYPE >=", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeLessThan(String value) {
            addCriterion("MATERIAL_TYPE <", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_TYPE <=", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeLike(String value) {
            addCriterion("MATERIAL_TYPE like", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeNotLike(String value) {
            addCriterion("MATERIAL_TYPE not like", value, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeIn(List<String> values) {
            addCriterion("MATERIAL_TYPE in", values, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeNotIn(List<String> values) {
            addCriterion("MATERIAL_TYPE not in", values, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeBetween(String value1, String value2) {
            addCriterion("MATERIAL_TYPE between", value1, value2, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_TYPE not between", value1, value2, "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusIsNull() {
            addCriterion("MATERIAL_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusIsNotNull() {
            addCriterion("MATERIAL_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusEqualTo(String value) {
            addCriterion("MATERIAL_STATUS =", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotEqualTo(String value) {
            addCriterion("MATERIAL_STATUS <>", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusGreaterThan(String value) {
            addCriterion("MATERIAL_STATUS >", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_STATUS >=", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLessThan(String value) {
            addCriterion("MATERIAL_STATUS <", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_STATUS <=", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLike(String value) {
            addCriterion("MATERIAL_STATUS like", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotLike(String value) {
            addCriterion("MATERIAL_STATUS not like", value, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusIn(List<String> values) {
            addCriterion("MATERIAL_STATUS in", values, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotIn(List<String> values) {
            addCriterion("MATERIAL_STATUS not in", values, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusBetween(String value1, String value2) {
            addCriterion("MATERIAL_STATUS between", value1, value2, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_STATUS not between", value1, value2, "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitIsNull() {
            addCriterion("MATERIAL_UNIT is null");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitIsNotNull() {
            addCriterion("MATERIAL_UNIT is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitEqualTo(String value) {
            addCriterion("MATERIAL_UNIT =", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitNotEqualTo(String value) {
            addCriterion("MATERIAL_UNIT <>", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitGreaterThan(String value) {
            addCriterion("MATERIAL_UNIT >", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_UNIT >=", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitLessThan(String value) {
            addCriterion("MATERIAL_UNIT <", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_UNIT <=", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitLike(String value) {
            addCriterion("MATERIAL_UNIT like", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitNotLike(String value) {
            addCriterion("MATERIAL_UNIT not like", value, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitIn(List<String> values) {
            addCriterion("MATERIAL_UNIT in", values, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitNotIn(List<String> values) {
            addCriterion("MATERIAL_UNIT not in", values, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitBetween(String value1, String value2) {
            addCriterion("MATERIAL_UNIT between", value1, value2, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_UNIT not between", value1, value2, "materialUnit");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeIsNull() {
            addCriterion("ON_PRODUCT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeIsNotNull() {
            addCriterion("ON_PRODUCT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeEqualTo(Date value) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME =", value, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME <>", value, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME >", value, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME >=", value, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeLessThan(Date value) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME <", value, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME <=", value, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeIn(List<Date> values) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME in", values, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME not in", values, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME between", value1, value2, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOnProductTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("ON_PRODUCT_TIME not between", value1, value2, "onProductTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeIsNull() {
            addCriterion("OM_MARKET_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeIsNotNull() {
            addCriterion("OM_MARKET_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeEqualTo(Date value) {
            addCriterionForJDBCDate("OM_MARKET_TIME =", value, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("OM_MARKET_TIME <>", value, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("OM_MARKET_TIME >", value, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("OM_MARKET_TIME >=", value, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeLessThan(Date value) {
            addCriterionForJDBCDate("OM_MARKET_TIME <", value, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("OM_MARKET_TIME <=", value, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeIn(List<Date> values) {
            addCriterionForJDBCDate("OM_MARKET_TIME in", values, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("OM_MARKET_TIME not in", values, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("OM_MARKET_TIME between", value1, value2, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andOmMarketTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("OM_MARKET_TIME not between", value1, value2, "omMarketTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeIsNull() {
            addCriterion("DOWN_PRODUCT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeIsNotNull() {
            addCriterion("DOWN_PRODUCT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeEqualTo(Date value) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME =", value, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME <>", value, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeGreaterThan(Date value) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME >", value, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME >=", value, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeLessThan(Date value) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME <", value, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME <=", value, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeIn(List<Date> values) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME in", values, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME not in", values, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME between", value1, value2, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andDownProductTimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("DOWN_PRODUCT_TIME not between", value1, value2, "downProductTime");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeIsNull() {
            addCriterion("MATERIAL_LIFE is null");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeIsNotNull() {
            addCriterion("MATERIAL_LIFE is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeEqualTo(Integer value) {
            addCriterion("MATERIAL_LIFE =", value, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeNotEqualTo(Integer value) {
            addCriterion("MATERIAL_LIFE <>", value, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeGreaterThan(Integer value) {
            addCriterion("MATERIAL_LIFE >", value, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeGreaterThanOrEqualTo(Integer value) {
            addCriterion("MATERIAL_LIFE >=", value, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeLessThan(Integer value) {
            addCriterion("MATERIAL_LIFE <", value, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeLessThanOrEqualTo(Integer value) {
            addCriterion("MATERIAL_LIFE <=", value, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeIn(List<Integer> values) {
            addCriterion("MATERIAL_LIFE in", values, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeNotIn(List<Integer> values) {
            addCriterion("MATERIAL_LIFE not in", values, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeBetween(Integer value1, Integer value2) {
            addCriterion("MATERIAL_LIFE between", value1, value2, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialLifeNotBetween(Integer value1, Integer value2) {
            addCriterion("MATERIAL_LIFE not between", value1, value2, "materialLife");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandIsNull() {
            addCriterion("MATERIAL_BRAND is null");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandIsNotNull() {
            addCriterion("MATERIAL_BRAND is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandEqualTo(String value) {
            addCriterion("MATERIAL_BRAND =", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandNotEqualTo(String value) {
            addCriterion("MATERIAL_BRAND <>", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandGreaterThan(String value) {
            addCriterion("MATERIAL_BRAND >", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL_BRAND >=", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandLessThan(String value) {
            addCriterion("MATERIAL_BRAND <", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL_BRAND <=", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandLike(String value) {
            addCriterion("MATERIAL_BRAND like", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandNotLike(String value) {
            addCriterion("MATERIAL_BRAND not like", value, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandIn(List<String> values) {
            addCriterion("MATERIAL_BRAND in", values, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandNotIn(List<String> values) {
            addCriterion("MATERIAL_BRAND not in", values, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandBetween(String value1, String value2) {
            addCriterion("MATERIAL_BRAND between", value1, value2, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandNotBetween(String value1, String value2) {
            addCriterion("MATERIAL_BRAND not between", value1, value2, "materialBrand");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNull() {
            addCriterion("SUPPLIER_ID is null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIsNotNull() {
            addCriterion("SUPPLIER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierIdEqualTo(String value) {
            addCriterion("SUPPLIER_ID =", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotEqualTo(String value) {
            addCriterion("SUPPLIER_ID <>", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThan(String value) {
            addCriterion("SUPPLIER_ID >", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdGreaterThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_ID >=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThan(String value) {
            addCriterion("SUPPLIER_ID <", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLessThanOrEqualTo(String value) {
            addCriterion("SUPPLIER_ID <=", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLike(String value) {
            addCriterion("SUPPLIER_ID like", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotLike(String value) {
            addCriterion("SUPPLIER_ID not like", value, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdIn(List<String> values) {
            addCriterion("SUPPLIER_ID in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotIn(List<String> values) {
            addCriterion("SUPPLIER_ID not in", values, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdBetween(String value1, String value2) {
            addCriterion("SUPPLIER_ID between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andSupplierIdNotBetween(String value1, String value2) {
            addCriterion("SUPPLIER_ID not between", value1, value2, "supplierId");
            return (Criteria) this;
        }

        public Criteria andIsSerializeIsNull() {
            addCriterion("IS_SERIALIZE is null");
            return (Criteria) this;
        }

        public Criteria andIsSerializeIsNotNull() {
            addCriterion("IS_SERIALIZE is not null");
            return (Criteria) this;
        }

        public Criteria andIsSerializeEqualTo(String value) {
            addCriterion("IS_SERIALIZE =", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeNotEqualTo(String value) {
            addCriterion("IS_SERIALIZE <>", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeGreaterThan(String value) {
            addCriterion("IS_SERIALIZE >", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeGreaterThanOrEqualTo(String value) {
            addCriterion("IS_SERIALIZE >=", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeLessThan(String value) {
            addCriterion("IS_SERIALIZE <", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeLessThanOrEqualTo(String value) {
            addCriterion("IS_SERIALIZE <=", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeLike(String value) {
            addCriterion("IS_SERIALIZE like", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeNotLike(String value) {
            addCriterion("IS_SERIALIZE not like", value, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeIn(List<String> values) {
            addCriterion("IS_SERIALIZE in", values, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeNotIn(List<String> values) {
            addCriterion("IS_SERIALIZE not in", values, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeBetween(String value1, String value2) {
            addCriterion("IS_SERIALIZE between", value1, value2, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIsSerializeNotBetween(String value1, String value2) {
            addCriterion("IS_SERIALIZE not between", value1, value2, "isSerialize");
            return (Criteria) this;
        }

        public Criteria andIndexSortIsNull() {
            addCriterion("INDEX_SORT is null");
            return (Criteria) this;
        }

        public Criteria andIndexSortIsNotNull() {
            addCriterion("INDEX_SORT is not null");
            return (Criteria) this;
        }

        public Criteria andIndexSortEqualTo(Integer value) {
            addCriterion("INDEX_SORT =", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotEqualTo(Integer value) {
            addCriterion("INDEX_SORT <>", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortGreaterThan(Integer value) {
            addCriterion("INDEX_SORT >", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortGreaterThanOrEqualTo(Integer value) {
            addCriterion("INDEX_SORT >=", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortLessThan(Integer value) {
            addCriterion("INDEX_SORT <", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortLessThanOrEqualTo(Integer value) {
            addCriterion("INDEX_SORT <=", value, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortIn(List<Integer> values) {
            addCriterion("INDEX_SORT in", values, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotIn(List<Integer> values) {
            addCriterion("INDEX_SORT not in", values, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_SORT between", value1, value2, "indexSort");
            return (Criteria) this;
        }

        public Criteria andIndexSortNotBetween(Integer value1, Integer value2) {
            addCriterion("INDEX_SORT not between", value1, value2, "indexSort");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIsNull() {
            addCriterion("CREATE_BY_ORG is null");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIsNotNull() {
            addCriterion("CREATE_BY_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgEqualTo(String value) {
            addCriterion("CREATE_BY_ORG =", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotEqualTo(String value) {
            addCriterion("CREATE_BY_ORG <>", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgGreaterThan(String value) {
            addCriterion("CREATE_BY_ORG >", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_ORG >=", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLessThan(String value) {
            addCriterion("CREATE_BY_ORG <", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_ORG <=", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLike(String value) {
            addCriterion("CREATE_BY_ORG like", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotLike(String value) {
            addCriterion("CREATE_BY_ORG not like", value, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgIn(List<String> values) {
            addCriterion("CREATE_BY_ORG in", values, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotIn(List<String> values) {
            addCriterion("CREATE_BY_ORG not in", values, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgBetween(String value1, String value2) {
            addCriterion("CREATE_BY_ORG between", value1, value2, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY_ORG not between", value1, value2, "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIsNull() {
            addCriterion("CREATE_BY_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIsNotNull() {
            addCriterion("CREATE_BY_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateByUserEqualTo(String value) {
            addCriterion("CREATE_BY_USER =", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotEqualTo(String value) {
            addCriterion("CREATE_BY_USER <>", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserGreaterThan(String value) {
            addCriterion("CREATE_BY_USER >", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_USER >=", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLessThan(String value) {
            addCriterion("CREATE_BY_USER <", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_BY_USER <=", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLike(String value) {
            addCriterion("CREATE_BY_USER like", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotLike(String value) {
            addCriterion("CREATE_BY_USER not like", value, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserIn(List<String> values) {
            addCriterion("CREATE_BY_USER in", values, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotIn(List<String> values) {
            addCriterion("CREATE_BY_USER not in", values, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserBetween(String value1, String value2) {
            addCriterion("CREATE_BY_USER between", value1, value2, "createByUser");
            return (Criteria) this;
        }

        public Criteria andCreateByUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_BY_USER not between", value1, value2, "createByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("UPDATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("UPDATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("UPDATE_TIME =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("UPDATE_TIME <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("UPDATE_TIME >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("UPDATE_TIME <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_TIME <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("UPDATE_TIME in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("UPDATE_TIME not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_TIME not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIsNull() {
            addCriterion("UPDATE_BY_ORG is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIsNotNull() {
            addCriterion("UPDATE_BY_ORG is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG =", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG <>", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgGreaterThan(String value) {
            addCriterion("UPDATE_BY_ORG >", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG >=", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLessThan(String value) {
            addCriterion("UPDATE_BY_ORG <", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_ORG <=", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLike(String value) {
            addCriterion("UPDATE_BY_ORG like", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotLike(String value) {
            addCriterion("UPDATE_BY_ORG not like", value, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgIn(List<String> values) {
            addCriterion("UPDATE_BY_ORG in", values, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotIn(List<String> values) {
            addCriterion("UPDATE_BY_ORG not in", values, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_ORG between", value1, value2, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_ORG not between", value1, value2, "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIsNull() {
            addCriterion("UPDATE_BY_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIsNotNull() {
            addCriterion("UPDATE_BY_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserEqualTo(String value) {
            addCriterion("UPDATE_BY_USER =", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotEqualTo(String value) {
            addCriterion("UPDATE_BY_USER <>", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserGreaterThan(String value) {
            addCriterion("UPDATE_BY_USER >", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_USER >=", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLessThan(String value) {
            addCriterion("UPDATE_BY_USER <", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_BY_USER <=", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLike(String value) {
            addCriterion("UPDATE_BY_USER like", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotLike(String value) {
            addCriterion("UPDATE_BY_USER not like", value, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserIn(List<String> values) {
            addCriterion("UPDATE_BY_USER in", values, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotIn(List<String> values) {
            addCriterion("UPDATE_BY_USER not in", values, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_USER between", value1, value2, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_BY_USER not between", value1, value2, "updateByUser");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNull() {
            addCriterion("IS_DELETE is null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIsNotNull() {
            addCriterion("IS_DELETE is not null");
            return (Criteria) this;
        }

        public Criteria andIsDeleteEqualTo(String value) {
            addCriterion("IS_DELETE =", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotEqualTo(String value) {
            addCriterion("IS_DELETE <>", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThan(String value) {
            addCriterion("IS_DELETE >", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteGreaterThanOrEqualTo(String value) {
            addCriterion("IS_DELETE >=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThan(String value) {
            addCriterion("IS_DELETE <", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLessThanOrEqualTo(String value) {
            addCriterion("IS_DELETE <=", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLike(String value) {
            addCriterion("IS_DELETE like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotLike(String value) {
            addCriterion("IS_DELETE not like", value, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteIn(List<String> values) {
            addCriterion("IS_DELETE in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotIn(List<String> values) {
            addCriterion("IS_DELETE not in", values, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteBetween(String value1, String value2) {
            addCriterion("IS_DELETE between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andIsDeleteNotBetween(String value1, String value2) {
            addCriterion("IS_DELETE not between", value1, value2, "isDelete");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNull() {
            addCriterion("TENANT_ID is null");
            return (Criteria) this;
        }

        public Criteria andTenantIdIsNotNull() {
            addCriterion("TENANT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTenantIdEqualTo(String value) {
            addCriterion("TENANT_ID =", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotEqualTo(String value) {
            addCriterion("TENANT_ID <>", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThan(String value) {
            addCriterion("TENANT_ID >", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdGreaterThanOrEqualTo(String value) {
            addCriterion("TENANT_ID >=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThan(String value) {
            addCriterion("TENANT_ID <", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLessThanOrEqualTo(String value) {
            addCriterion("TENANT_ID <=", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdLike(String value) {
            addCriterion("TENANT_ID like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotLike(String value) {
            addCriterion("TENANT_ID not like", value, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdIn(List<String> values) {
            addCriterion("TENANT_ID in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotIn(List<String> values) {
            addCriterion("TENANT_ID not in", values, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdBetween(String value1, String value2) {
            addCriterion("TENANT_ID between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andTenantIdNotBetween(String value1, String value2) {
            addCriterion("TENANT_ID not between", value1, value2, "tenantId");
            return (Criteria) this;
        }

        public Criteria andMaterialIdLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_ID) like", value.toUpperCase(), "materialId");
            return (Criteria) this;
        }

        public Criteria andMaterialNameLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_NAME) like", value.toUpperCase(), "materialName");
            return (Criteria) this;
        }

        public Criteria andMaterialTypeLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_TYPE) like", value.toUpperCase(), "materialType");
            return (Criteria) this;
        }

        public Criteria andMaterialStatusLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_STATUS) like", value.toUpperCase(), "materialStatus");
            return (Criteria) this;
        }

        public Criteria andMaterialUnitLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_UNIT) like", value.toUpperCase(), "materialUnit");
            return (Criteria) this;
        }

        public Criteria andMaterialBrandLikeInsensitive(String value) {
            addCriterion("upper(MATERIAL_BRAND) like", value.toUpperCase(), "materialBrand");
            return (Criteria) this;
        }

        public Criteria andSupplierIdLikeInsensitive(String value) {
            addCriterion("upper(SUPPLIER_ID) like", value.toUpperCase(), "supplierId");
            return (Criteria) this;
        }

        public Criteria andIsSerializeLikeInsensitive(String value) {
            addCriterion("upper(IS_SERIALIZE) like", value.toUpperCase(), "isSerialize");
            return (Criteria) this;
        }

        public Criteria andCreateByOrgLikeInsensitive(String value) {
            addCriterion("upper(CREATE_BY_ORG) like", value.toUpperCase(), "createByOrg");
            return (Criteria) this;
        }

        public Criteria andCreateByUserLikeInsensitive(String value) {
            addCriterion("upper(CREATE_BY_USER) like", value.toUpperCase(), "createByUser");
            return (Criteria) this;
        }

        public Criteria andUpdateByOrgLikeInsensitive(String value) {
            addCriterion("upper(UPDATE_BY_ORG) like", value.toUpperCase(), "updateByOrg");
            return (Criteria) this;
        }

        public Criteria andUpdateByUserLikeInsensitive(String value) {
            addCriterion("upper(UPDATE_BY_USER) like", value.toUpperCase(), "updateByUser");
            return (Criteria) this;
        }

        public Criteria andIsDeleteLikeInsensitive(String value) {
            addCriterion("upper(IS_DELETE) like", value.toUpperCase(), "isDelete");
            return (Criteria) this;
        }

        public Criteria andTenantIdLikeInsensitive(String value) {
            addCriterion("upper(TENANT_ID) like", value.toUpperCase(), "tenantId");
            return (Criteria) this;
        }
    }

    /**
     * 类注释
     * Criteria
     * 数据库表：dpt_material
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * 类注释
     * Criterion
     * 数据库表：dpt_material
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}